package com.ruoyi.work.mapper;

import com.ruoyi.work.domain.TbLocationTrain;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * 车辆位置Mapper接口
 *
 * @author szm
 * @date 2025-09-28
 */
public interface TbLocationTrainMapper extends BaseMapper<TbLocationTrain> {

    @Select("select * from tb_location_train where termina_phone = #{terminaPhone} and work_no = #{workNo} ORDER BY last_time desc limit 1")
    TbLocationTrain getByPhono(@Param("terminaPhone") String terminaPhone, @Param("workNo") String workNo);

}
